CREATE procedure [dbo].[BAEImisOrdersGetAllUsersByDateRange] @USERID as
varchar(10),
        @START_DATE     AS     datetime,
        @END_DATE        AS    datetime
AS
    SELECT *
    FROM Orders
    WHERE BT_ID = @USERID AND ORDER_DATE BETWEEN @START_DATE AND @END_DATE
    ORDER BY ORDER_NUMBER DESC;


----------------------------------


set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON

GO